package com.sixuerain.heartkey.prayer.db.table;

public class HomeworkTable implements TableBase {

	public static final String TAG = "HomeworkTable";
	public static final String TABLE_NAME = "T_HW_Lection";
	public static final String ID = "Id";
	public static final String HWNAME = "HWName";
	public static final String HWOWNER = "HWOwner";
	public static final String HWGAINER = "HWGainer";
	public static final String HWOWNER_NAME = "HWOwnerName";
	public static final String HWGAINER_NAME = "HWGainerName";
	public static final String LECTIONID = "LectionId";
	public static final String HWNOTES = "HWNOTES";
	
	
	public static final String[] TABLE_COLUMNS = new String[] { ID,
		HWNAME, HWOWNER, HWGAINER,LECTIONID };

	public static final String CREATE_TABLE = 
	"create Table " + TABLE_NAME + "( " +
		  ID + " integer primary key," +
		  HWNAME + " Nvarchar(200)," +
		  HWOWNER + " integer," +
		  HWOWNER_NAME + " Nvarchar(200)," +
		  HWGAINER + " integer," +
		  HWGAINER_NAME + " Nvarchar(200)," +
		  HWNOTES + " nvarchar(500)," +
		  LECTIONID + " integer," +
		  "CreateDate TIMESTAMP," +
		  "updateDate TIMESTAMP," +
		  "Creator integer," +
		  "updator integer" +
		");";

}